error-凯发app苹果版
file:en/product.xmls
method:query.scalar(columns,*where,*order)
语法错误 (操作符丢失) 在查询表达式 'status>0 and and 1<0' 中。
select top 1 count(*) from newscontent where status>0 and and 1<0
越界或超过范围
en/product.xmls
...
$if(@t==1){
@ids=$array();
@query[parentid]=$http.argv(2);
@query[catalogid]=$http.argv(2);
@form2=@query.getrow(*,['catalogid={*catalogid}']);
@title1=@form2[catalogname];
@cataid=$http.argv(2);
@cataname=@title1;
@catalist=@query.gettable(['catalogid'],['status>0 and areaid=3 and parentid={*parentid}']);
@ids=@catalist.toarray(['catalogid']);
@query=$query(content,news);
@query[catalogid]=@ids;
@search=[''];
@description=[''];
@t=1;
@sql=['status>0 and {#in(catalogid)} '];
@count=@query.scalar(['count(*)'],@sql);
@index=$http.get(page,#n,1);
@product=@query.getlist(['contentid,title,pic,subtitle,createdate,grade'],['status>0 and areaid=3 and {#in(catalogid)} '],['grade desc,{#idn(0)} desc'],15,@count,@index);
@pager=$util.pager(15,@count,@index,page,3);
@contenlist=@query.datalist(['select * from newscontent where userid=1 and areaid=3 order by grade desc, modified desc']);
}
$if(@t==2){
@search=$http.argv(2);
@ids=$array();
@ids=@catalist.toarray(['cata...